home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
DOS/V Power Report 2004 April
/
VPR0404.ISO
/
PCTUNE
/
AIDA32EE_390
/
aida32ee_390.exe
/
{app}
/
DB - Oracle.sql
< prev
next >
Wrap
Text File
|
2004-01-20
|
1KB
|
40 lines
DROP SEQUENCE seqItem;
CREATE SEQUENCE seqItem MINVALUE 1 MAXVALUE 1000000000 CYCLE;
DROP SEQUENCE seqReport;
CREATE SEQUENCE seqReport MINVALUE 1 MAXVALUE 1000000000 CYCLE;
DROP TABLE Item;
DROP TABLE Report;
DROP TABLE NextID;
CREATE TABLE Report (
ID INTEGER PRIMARY KEY,
RVersion VARCHAR2(255),
RHost VARCHAR2(255),
RUser VARCHAR2(255),
RLocation VARCHAR2(255),
RDateTime VARCHAR2(16),
RComplete NUMBER(1) NOT NULL
);
CREATE TABLE Item (
ID INTEGER PRIMARY KEY,
IPage VARCHAR2(100),
IDevice VARCHAR2(255),
IGroup VARCHAR2(255),
IField VARCHAR2(255),
IValue VARCHAR2(255),
IIcon INTEGER,
IID INTEGER,
ReportID INTEGER REFERENCES Report(ID)
);
CREATE TABLE NextID (
TableName VARCHAR2(6) PRIMARY KEY,
NextID INTEGER NOT NULL
);
INSERT INTO NextID (TableName, NextID) VALUES ('Item', 1);
INSERT INTO NextID (TableName, NextID) VALUES ('Report', 1);